create external table jms_ods.tab_direct_rule_config
(
  id                    bigint,
  one_vehicle_min_mile  decimal(10,2) comment '9.6米车型最小里程(KM)',
  one_vehicle_max_mile  decimal(10,2) comment '9.6米车型最大里程(KM)',
  one_vehicle_load_rate decimal(10,2) comment '9.6米车型装载率(百分比)',
  two_vehicle_min_mile  decimal(10,2) comment '16.5米车型最小里程(KM)',
  two_vehicle_max_mile  decimal(12,2) comment '16.5米车型最大里程(KM)',
  two_vehicle_load_rate decimal(10,2) comment '16.5米车型装载率(百分比)',
  stock_proportion_min  decimal(10,2) comment '囤货占比最小值(百分比)',
  stock_proportion_max  decimal(10,2) comment '囤货占比最大值(百分比)',
  stock_number_min      decimal(10,2) comment '囤货件量最小值(立方米)',
  volume_divisor        decimal(10,2) comment '总体积除数(方)',
  create_time           timestamp comment '创建日期',
  create_user           string comment '创建人'
)comment '够量直发规则配置表'
 PARTITIONED BY (
   `dt` string COMMENT '时间分区(yyyyMMdd)')
stored as parquet
 LOCATION
   '/dw/hive/jms_ods.db/external/tab_direct_rule_config'
     TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );